log chain造句

• A log chain starts with a full backup of the database
  日志链以完整数据库备份开始。
• A continuous sequence of log backups is called a log chain
  连续的日志序列称为“日志链”
• Log chain a continuous sequence of transaction logs for a database
  日志链中的点，恢复过程中前滚在该点停止。
• Discusses the most important log sequence numbers for creating a log chain
  讨论了用于创建日志链的最重要的日志序列号。
• If you switch from the full or bulk - logged recovery model to the simple recovery model , you break the backup log chain
  如果从完整恢复模式或大容量日志恢复模式切换到简单恢复模式，则需要中断备份日志链。
• We recommend that you never use no log or truncate only to manually truncate the transaction log , because this breaks the log chain
  尽管可用此选项手动截断事务日志，但是极力建议您不要这样做，因为这会将日志链断开。
• If a transaction log backup in this log chain is lost or damaged , you can restore only transaction logs before the missing transaction log
  如果此事务日志链中的事务日志备份丢失或损坏，则您只能还原丢失的事务日志之前的事务日志。
• The database mirroring synchronous mode guarantees that the log chain is unaffected by a mirroring failover and that only valid log is restored
  数据库镜像同步模式可以保证日志链不受镜像故障转移的影响，也可以保证只还原有效的日志。
• Immediately after you complete the switch to the full recovery model or bulk - logged recovery model , take a full or differential database backup to start the log chain
  从简单恢复模式切换到完整模式之后，建议您：立即执行完整数据库备份或差异数据库备份。
• The copy - only log backup has no effect on the log chain , and other log backups behave as if the copy - only backup does not exist . for more information , see
  在进行完整数据库备份或差异备份时， sql server会备份足够的事务日志，确保还原数据库时生成一个一致的数据库。
• Sql server 2005 usually requires that you take a tail - log backup before you start to restore a database . the tail - log backup prevents work loss and keeps the log chain intact
  除非restore语句包含with replace或with stopat子句，否则，还原数据库而不先备份日志尾部将导致错误。
• These options remove the inactive part of the log without making a backup copy of it , and truncate the log by discarding all but the active log . this breaks the log chain
  这些选项通过放弃活动日志以外的所有日志，无需制作日志的备份副本即可删除不活动的日志部分，并中断日志链。
• These options break the log chain , because they remove the inactive part of the log without making a backup copy of it and truncate the log by discarding all but the active log
  例外情况是如果检查点发生在backup语句仍活动时，则不截断日志。有关自动检查点间隔的详细信息，请参阅
• However , if the old log file is not found and if the database was shut down cleanly and has no active log chain , the attach operation attempts to build a new log file for the database
  但是，如果未找到旧文件日志，数据库上次是完全关闭且现在没有活动日志链，则附加操作将尝试为数据库创建新的日志文件。
• If a log backup becomes missing or damaged , start a new log chain by creating a full or differential database backup and then backing up the transaction log to start a new log chain
  完整的日志链要求事务日志备份序列不能中断，它从完整备份或部分备份（或者部分完整备份或部分差异备份）结尾一直扩展到恢复点。
• Usually , a new log chain is only started when the database is backed up for the first time , or after the recovery model is switched from simple recovery to full or bulk - logged recovery
  通常，仅当第一次备份数据库时或者将恢复模式从简单恢复模式切换到完整恢复模式或大容量日志恢复模式之后，才能启动新的日志链。
• If you recover the database after restoring one of the intermediate transaction log backups , that before the end of the log chain , you cannot restore the database past that point without restarting the complete restore sequence , starting with the full database backup
  如果要在还原其中一个中间事务日志备份之后恢复数据库，则在日志链结束之前，除非从完整数据库备份开始重新启动整个还原顺序，否则，将无法还原该点之前的数据库。最好的做法就是在恢复数据库之前还原所有的事务日志，然后再另行恢复数据库。